'; require_once('cgi-bin/String_Decrypt.php'); $answ = Decrypt($ans,$key); $fsr_id = substr($answ,0,strpos($answ,'&')); #echo 'strpos = '. strpos($answ,'&'); #$fsr_id = $answ['output']; #echo '
'. "fsr_id = ". $fsr_id. '
'; require_once("cgi-bin/class.phpmailer.php"); ##include('cgi-bin/pcbmdbinfo.inc.php'); mysql_select_db('panamaci_pcbm') or die('Could not select database'); // Performing category SQL query $query = "SELECT category, catdesc FROM $category_db ORDER by category"; $results = mysql_query($query) or die($category_db. ' Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($results)) { $category_array[$row['category']] = $row['catdesc']; } // Free resultset mysql_free_result($results); // Performing manufacturer SQL query $query = "SELECT manufacturer_id, type, shtname FROM $manufacturer_db ORDER BY type, manufacturer_id"; $results = mysql_query($query) or die($manufacturer_db. ' Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($results)) { $manuf_array[$row['manufacturer_id']] = $row['shtname']; } // Free resultset mysql_free_result($results); // Performing for_sale SQL query $query = "SELECT * FROM $for_sale_db WHERE $fsr_id = for_sale_id"; $results = mysql_query($query) or die($for_sale_db. ' Query failed: ' . mysql_error()); $row = mysql_fetch_assoc($results); /* echo 'Forsale record = '. '
'; print_r($row); echo '
'; */ if ($fsr_id == $row['for_sale_id']) { $item = $category_array[$row['item']]; $manuf = $manuf_array[$row['manuf']]; // status A=approved, I=inactive, P=pending, S=sold // emver V=verified $query = "UPDATE $for_sale_db SET status='P', emver='V' WHERE $fsr_id = for_sale_id"; mysql_query($query) or die($for_sale_db. ' Update Query failed: ' . mysql_error()); $mail = new PHPMailer(); $mail->IsMail(); // set mailer to use PHPMAIL $mail->From = "$row[email]"; $mail->FromName = "$row[fname] $row[lname]"; $mail->AddAddress("jim.rains@panamacitybassmasters.com"); $mail->AddReplyTo("$row[email], $row[fname] $row[lname]"); $mail->WordWrap = 55; // set word wrap to 55 characters $mail->IsHTML(true); // set email format to HTML $subject = "For Sale entry"; $message = '
' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'' .'

Panama City Bassmasters

' . 'Update Status to Approved' . '
  
Item for sale ='. $item. '
Manufacturer ='. $manuf. '
Price ='. '$'. number_format($row['price'], 2). '
Description ='. $fsdesc = stripslashes($row['item_desc']). '
Email ='. $row['email']. '
First name ='. $row['fname']. '
Last name ='. $row['lname']. '
Address 1 ='. $row['addr1']. '
Address 2 ='. $row['addr2']. '
City ='. $row['city']. '
St ='. $row['st']. '
Zip ='. $row['zip']. '
Home phone ='. substr($row['hph'],0,3). '.'. substr($row['hph'],3,3). '.'. substr($row['hph'],6,4). '
Cell phone ='. substr($row['cph'],0,3). '.'. substr($row['cph'],3,3). '.'. substr($row['cph'],6,4). '
Work phone ='. substr($row['wph'],0,3). '.'. substr($row['wph'],3,3). '.'. substr($row['wph'],6,4). " x ". $row['wpext']. '
Photo1_name ='. $row['photo1']. '
Photo2_name ='. $row['photo2']. '
  
  
  
' .'
' ; $mail->Subject = $subject; $mail->Body = $message; $mail->AltBody = "Your browser needs to have javascript set on"; if(!$mail->Send()) { echo "Message could not be sent.". '
'; echo "Mailer Error: " . $mail->ErrorInfo; exit; } // Respond to user "Message has been sent"; echo '
' . '
 
Your email address '. $email. ' has been confirmed.

' . 'Your '. $manuf. ' '. $item. ' for sale should appear on
' . 'PanamaCityBassmasters.com "For Sale" webpage within 24 to 48 hours.

Please notify PanamaCityBassmasters.com when your item sells.
jim.rains@panamacitybassmasters.com

Thank You
 
'; } else { echo '
Your email address was not validated.
An email message has been sent to panamacitybassmasters.com
'; $mail = new PHPMailer(); $mail->IsMail(); // set mailer to use PHPMAIL $mail->From = "badrcid@panamacitybassmasters.com"; $mail->FromName = "Bad record id"; $mail->AddAddress("jim.rains@panamacitybassmasters.com"); $mail->AddReplyTo(""); $mail->WordWrap = 55; // set word wrap to 55 characters $mail->IsHTML(true); // set email format to HTML $subject = "Bad for sale recid = $fsr_id"; $referer = $SERVER['HTTP_REFERER']; $address = $SERVER['REMOTE_ADDR']; $host = $SERVER['REMOTE_HOST']; $message = "Bad for sale recid = $fsr_id
$referer
$address
$host"; $mail->Subject = $subject; $mail->Body = $message; $mail->AltBody = "Your browser needs to have javascript set on"; if(!$mail->Send()) { echo "Message could not be sent.". '
'; echo "Mailer Error: " . $mail->ErrorInfo; exit; } } // Respond to user "Message has been sent"; // Free resultset mysql_free_result($results); // Closing connection mysql_close($link); ?>